www.gusucode.com > 婚庆仪礼策划公司网站系统源代码 梦紫色 > 婚庆仪礼策划公司网站系统源代码 梦紫色/Admin/inc/book_body.asp
<%sub book_body()
dim totalnews,Currentpage,totalpages,i
sql="select * from msg order by m_id DESC"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
%>
<HTML><HEAD><TITLE>管理中心</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312"><LINK
href="inc/djcss.css" type=text/css rel=StyleSheet>
<META content="MSHTML 6.00.2800.1126" name=GENERATOR>
</HEAD>
<body onkeydown=return(!(event.keyCode==78&&event.ctrlKey)) background=inc/dj_bg.gif>
<table align="center" width="98%" border="1" cellspacing="0" cellpadding="4" bordercolor="#C0C0C0" style="border-collapse: collapse">
<tr>
<td align="center" valign="middle" bgcolor="#E8E8E8">留言管理</td>
</tr>
<tr bgcolor="#E8E8E8" align="center">
<td class="chinese" width="10%" bgcolor="#F5F5F5">编号</td>
<td class="chinese" width="70%" bgcolor="#F5F5F5">标题</td>
<td class="chinese" width="20%" bgcolor="#F5F5F5">操作</td>
</tr>
<%if Not rs.EOF then
dim newsperpage
dim page1
newsperpage=10
rs.movefirst
rs.pagesize=newsperpage
if trim(request("page"))<>"" then
page1=trim(request("page"))
if check_num(page1)=true then
currentpage=clng(request("page"))
if currentpage>rs.pagecount then
currentpage=rs.pagecount
End if
else
currentpage=1
end if
else
currentpage=1
End if
totalnews=rs.recordcount
if currentpage<>1 then
if (currentpage-1)*newsperpage<totalnews then
rs.move(currentpage-1)*newsperpage
dim bookmark
bookmark=rs.bookmark
End if
End if
if (totalnews mod newsperpage)=0 then
totalpages=totalnews\newsperpage
else
totalpages=totalnews\newsperpage+1
End if
i=0
Do While Not rs.EOF and i<newsperpage%>
<tr>
<td bgcolor="#FFFFFF" class="chinese" align="center"><%=rs("m_id")%> </td>
<td bgcolor="#FFFFFF" class="chinese">[<span class="date"><%=rs("m_date")%></span>] <a href="admin_book.asp?m_id=<%=rs("m_id")%>&action=viewbook"><%=rs("m_title")%></a> </td>
<td bgcolor="#FFFFFF" class="chinese" align="center"><a href="admin_book.asp?m_id=<%=rs("m_id")%>&action=viewbook">查看</a> <a href="admin_book.asp?id=<%=rs("m_id")%>&action=delbook">删除</a></td>
</tr>
<%i=i+1
rs.movenext
loop
else
if rs.EOF and rs.BOF then%>
<tr align="center">
<td bgcolor="#FFFFFF" colspan="3" class="chinese">当前没有留言！</td>
</tr>
<%End if
End if%>
</table>
</table>
<table align="center" width="98%" border="0" cellspacing="0" cellpadding="0">
<form name="form2" method="post" action="admin_book.asp">
<tr>
<td class="chinese" align="right"><%=currentpage%> /<%=totalpages%>页,<%=totalnews%>条记录/<%=newsperpage%>篇每页.
<%
i=1
showye=totalpages
if showye>10 then
showye=10
End if
for i=1 to showye
if i=currentpage then
%>
<%=i%>
<%else%>
<a href="admin_book.asp?page=<%=i%>"><%=i%></a>
<%End if
next
if totalpages>currentpage then
if request("page")="" then
page=1
else
page=request("page")+1
End if%>
<a href="admin_book.asp?page=<%=page%>" title="下一页">>></a>
<%End if%>
<input type="text" name="page" class="textarea" size="4">
<input type="submit" name="Submit" value="Go" class="button"></td>
</tr>
</form>
</table>
<%
if request.QueryString("action")="viewbook" then
if request.querystring("m_id")="" then
errmsg=errmsg+"<br>"+"<li>请指定操作的对象！"
Call diserror()
response.End
else
if Not isinteger(request.querystring("m_id")) then
errmsg=errmsg+"<br>"+"<li>非法的ID参数！"
Call diserror()
response.End
End if
End if
sql="select * from msg where m_id="&cint(request.querystring("m_id"))
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
if Not(rs.BOF or rs.EOF) then
%>
<table width="98%" border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#e5e5e5">
<form action="admin_book.asp" method="post" name="form0" target="_self">
<input name="action" type="hidden" value="delbook">
<input name="id" type="hidden" value=<%= cint(request.querystring("m_id")) %>>
<tr bgcolor="#FFFFFF">
<td height="25" colspan="6" bgcolor="#F5F5F5"> 查看留言 留言人：<%= rs("m_name") %> 留言时间:<%= rs("m_date") %></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="12%" height="25" align="right" valign="middle"> 主 题:</td>
<td height="25" colspan="5" align="left" valign="middle"><%= rs("m_title") %></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="25" align="right" valign="middle"> 邮件地址:</td>
<td width="27%" height="25"><%= rs("m_email") %></td>
<td width="11%">联系电话：</td>
<td width="20%"><%= rs("m_tel") %></td>
<td width="10%">传真号码：</td>
<td width="20%"><%= rs("m_fax") %></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="25" align="right" valign="middle"> 详细地址:</td>
<td height="25" colspan="5"><%= rs("m_city") %> <%= rs("m_addr") %></td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="right" valign="middle">留言内容:</td>
<td colspan="5"><%= formatStr(rs("m_text")) %></td>
</tr>
<tr align="center" valign="middle" bgcolor="#FFFFFF">
<td height="30" colspan="6"><input type="submit" name="Submit" value=" 删除 " class="button">
<input type="button" name="Submit" value=" 返回 " onClick="javascript:history.back()" class="button"></td>
</tr>
</form>
</table>
<%
End if
End if
%>
<br>
</td>
</tr>
<tr>
<td colspan="3" height="1" background="images/dotlineh.gif"></td>
</tr>
</table>
<%
rs.close
set rs=Nothing
End sub%>